﻿    /***************************************************************************************************
    **  Table:	    public.country
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents contries listed in ISO 3166.
    **    
    **    Further information to be pulled from ISO's Online Browsing Portal at:
    **    
    **    https://www.iso.org/obp/ui/#iso:code:3166:GB
    **    
    **    Where GB is the 2-letter country code (alpha-2)
    **    
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    **      The full name, short name and particularly the display name is to be further refined.
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AF', 'AFG', 4, 'Afghanistan', 'Afghanistan', 'Afghanistan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AX', 'ALA', 248, 'Åland Islands', 'Åland Islands', 'Åland Islands');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AL', 'ALB', 8, 'Albania', 'Albania', 'Albania');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DZ', 'DZA', 12, 'Algeria', 'Algeria', 'Algeria');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AS', 'ASM', 16, 'American Samoa', 'American Samoa', 'American Samoa');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AD', 'AND', 20, 'Andorra', 'Andorra', 'Andorra');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AO', 'AGO', 24, 'Angola', 'Angola', 'Angola');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AI', 'AIA', 660, 'Anguilla', 'Anguilla', 'Anguilla');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AQ', 'ATA', 10, 'Antarctica', 'Antarctica', 'Antarctica');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AG', 'ATG', 28, 'Antigua and Barbuda', 'Antigua and Barbuda', 'Antigua and Barbuda');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AR', 'ARG', 32, 'Argentina', 'Argentina', 'Argentina');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AM', 'ARM', 51, 'Armenia', 'Armenia', 'Armenia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AW', 'ABW', 533, 'Aruba', 'Aruba', 'Aruba');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AU', 'AUS', 36, 'Australia', 'Australia', 'Australia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AT', 'AUT', 40, 'Austria', 'Austria', 'Austria');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AZ', 'AZE', 31, 'Azerbaijan', 'Azerbaijan', 'Azerbaijan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BS', 'BHS', 44, 'Bahamas (the)', 'Bahamas (the)', 'Bahamas (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BH', 'BHR', 48, 'Bahrain', 'Bahrain', 'Bahrain');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BD', 'BGD', 50, 'Bangladesh', 'Bangladesh', 'Bangladesh');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BB', 'BRB', 52, 'Barbados', 'Barbados', 'Barbados');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BY', 'BLR', 112, 'Belarus', 'Belarus', 'Belarus');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BE', 'BEL', 56, 'Belgium', 'Belgium', 'Belgium');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BZ', 'BLZ', 84, 'Belize', 'Belize', 'Belize');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BJ', 'BEN', 204, 'Benin', 'Benin', 'Benin');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BM', 'BMU', 60, 'Bermuda', 'Bermuda', 'Bermuda');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BT', 'BTN', 64, 'Bhutan', 'Bhutan', 'Bhutan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BO', 'BOL', 68, 'Bolivia (Plurinational State of)', 'Bolivia (Plurinational State of)', 'Bolivia (Plurinational State of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BQ', 'BES', 535, 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius and Saba');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BW', 'BWA', 72, 'Botswana', 'Botswana', 'Botswana');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BV', 'BVT', 74, 'Bouvet Island', 'Bouvet Island', 'Bouvet Island');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BR', 'BRA', 76, 'Brazil', 'Brazil', 'Brazil');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IO', 'IOT', 86, 'British Indian Ocean Territory (the)', 'British Indian Ocean Territory (the)', 'British Indian Ocean Territory (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BN', 'BRN', 96, 'Brunei Darussalam', 'Brunei Darussalam', 'Brunei Darussalam');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BG', 'BGR', 100, 'Bulgaria', 'Bulgaria', 'Bulgaria');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BF', 'BFA', 854, 'Burkina Faso', 'Burkina Faso', 'Burkina Faso');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BI', 'BDI', 108, 'Burundi', 'Burundi', 'Burundi');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CV', 'CPV', 132, 'Cabo Verde', 'Cabo Verde', 'Cabo Verde');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KH', 'KHM', 116, 'Cambodia', 'Cambodia', 'Cambodia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CM', 'CMR', 120, 'Cameroon', 'Cameroon', 'Cameroon');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CA', 'CAN', 124, 'Canada', 'Canada', 'Canada');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KY', 'CYM', 136, 'Cayman Islands (the)', 'Cayman Islands (the)', 'Cayman Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CF', 'CAF', 140, 'Central African Republic (the)', 'Central African Republic (the)', 'Central African Republic (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TD', 'TCD', 148, 'Chad', 'Chad', 'Chad');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CL', 'CHL', 152, 'Chile', 'Chile', 'Chile');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CN', 'CHN', 156, 'China', 'China', 'China');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CX', 'CXR', 162, 'Christmas Island', 'Christmas Island', 'Christmas Island');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CC', 'CCK', 166, 'Cocos (Keeling) Islands (the)', 'Cocos (Keeling) Islands (the)', 'Cocos (Keeling) Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CO', 'COL', 170, 'Colombia', 'Colombia', 'Colombia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KM', 'COM', 174, 'Comoros (the)', 'Comoros (the)', 'Comoros (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CD', 'COD', 180, 'Congo (the Democratic Republic of the)', 'Congo (the Democratic Republic of the)', 'Congo (the Democratic Republic of the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CG', 'COG', 178, 'Congo (the)', 'Congo (the)', 'Congo (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CK', 'COK', 184, 'Cook Islands (the)', 'Cook Islands (the)', 'Cook Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CR', 'CRI', 188, 'Costa Rica', 'Costa Rica', 'Costa Rica');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CI', 'CIV', 384, 'Côte d''Ivoire', 'Côte d''Ivoire', 'Côte d''Ivoire');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HR', 'HRV', 191, 'Croatia', 'Croatia', 'Croatia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CU', 'CUB', 192, 'Cuba', 'Cuba', 'Cuba');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CW', 'CUW', 531, 'Curaçao', 'Curaçao', 'Curaçao');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CY', 'CYP', 196, 'Cyprus', 'Cyprus', 'Cyprus');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CZ', 'CZE', 203, 'Czech Republic (the)', 'Czech Republic (the)', 'Czech Republic (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DK', 'DNK', 208, 'Denmark', 'Denmark', 'Denmark');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DJ', 'DJI', 262, 'Djibouti', 'Djibouti', 'Djibouti');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DM', 'DMA', 212, 'Dominica', 'Dominica', 'Dominica');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DO', 'DOM', 214, 'Dominican Republic (the)', 'Dominican Republic (the)', 'Dominican Republic (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('EC', 'ECU', 218, 'Ecuador', 'Ecuador', 'Ecuador');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('EG', 'EGY', 818, 'Egypt', 'Egypt', 'Egypt');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SV', 'SLV', 222, 'El Salvador', 'El Salvador', 'El Salvador');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Equatorial Guinea', 'Equatorial Guinea');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ER', 'ERI', 232, 'Eritrea', 'Eritrea', 'Eritrea');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('EE', 'EST', 233, 'Estonia', 'Estonia', 'Estonia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ET', 'ETH', 231, 'Ethiopia', 'Ethiopia', 'Ethiopia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FK', 'FLK', 238, 'Falkland Islands (the) [Malvinas]', 'Falkland Islands (the) [Malvinas]', 'Falkland Islands (the) [Malvinas]');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FO', 'FRO', 234, 'Faroe Islands (the)', 'Faroe Islands (the)', 'Faroe Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FJ', 'FJI', 242, 'Fiji', 'Fiji', 'Fiji');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FI', 'FIN', 246, 'Finland', 'Finland', 'Finland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FR', 'FRA', 250, 'France', 'France', 'France');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GF', 'GUF', 254, 'French Guiana', 'French Guiana', 'French Guiana');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PF', 'PYF', 258, 'French Polynesia', 'French Polynesia', 'French Polynesia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TF', 'ATF', 260, 'French Southern Territories (the)', 'French Southern Territories (the)', 'French Southern Territories (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GA', 'GAB', 266, 'Gabon', 'Gabon', 'Gabon');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GM', 'GMB', 270, 'Gambia (the)', 'Gambia (the)', 'Gambia (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GE', 'GEO', 268, 'Georgia', 'Georgia', 'Georgia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('DE', 'DEU', 276, 'Germany', 'Germany', 'Germany');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GH', 'GHA', 288, 'Ghana', 'Ghana', 'Ghana');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GI', 'GIB', 292, 'Gibraltar', 'Gibraltar', 'Gibraltar');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GR', 'GRC', 300, 'Greece', 'Greece', 'Greece');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GL', 'GRL', 304, 'Greenland', 'Greenland', 'Greenland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GD', 'GRD', 308, 'Grenada', 'Grenada', 'Grenada');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GP', 'GLP', 312, 'Guadeloupe', 'Guadeloupe', 'Guadeloupe');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GU', 'GUM', 316, 'Guam', 'Guam', 'Guam');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GT', 'GTM', 320, 'Guatemala', 'Guatemala', 'Guatemala');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GG', 'GGY', 831, 'Guernsey', 'Guernsey', 'Guernsey');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GN', 'GIN', 324, 'Guinea', 'Guinea', 'Guinea');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GW', 'GNB', 624, 'Guinea-Bissau', 'Guinea-Bissau', 'Guinea-Bissau');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GY', 'GUY', 328, 'Guyana', 'Guyana', 'Guyana');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HT', 'HTI', 332, 'Haiti', 'Haiti', 'Haiti');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VA', 'VAT', 336, 'Holy See (the)', 'Holy See (the)', 'Holy See (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HN', 'HND', 340, 'Honduras', 'Honduras', 'Honduras');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HK', 'HKG', 344, 'Hong Kong', 'Hong Kong', 'Hong Kong');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('HU', 'HUN', 348, 'Hungary', 'Hungary', 'Hungary');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IS', 'ISL', 352, 'Iceland', 'Iceland', 'Iceland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IN', 'IND', 356, 'India', 'India', 'India');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ID', 'IDN', 360, 'Indonesia', 'Indonesia', 'Indonesia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IR', 'IRN', 364, 'Iran (Islamic Republic of)', 'Iran (Islamic Republic of)', 'Iran (Islamic Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IQ', 'IRQ', 368, 'Iraq', 'Iraq', 'Iraq');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IE', 'IRL', 372, 'Ireland', 'Ireland', 'Ireland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IM', 'IMN', 833, 'Isle of Man', 'Isle of Man', 'Isle of Man');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IL', 'ISR', 376, 'Israel', 'Israel', 'Israel');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('IT', 'ITA', 380, 'Italy', 'Italy', 'Italy');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('JM', 'JAM', 388, 'Jamaica', 'Jamaica', 'Jamaica');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('JP', 'JPN', 392, 'Japan', 'Japan', 'Japan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('JE', 'JEY', 832, 'Jersey', 'Jersey', 'Jersey');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('JO', 'JOR', 400, 'Jordan', 'Jordan', 'Jordan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KZ', 'KAZ', 398, 'Kazakhstan', 'Kazakhstan', 'Kazakhstan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KE', 'KEN', 404, 'Kenya', 'Kenya', 'Kenya');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KI', 'KIR', 296, 'Kiribati', 'Kiribati', 'Kiribati');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KP', 'PRK', 408, 'Korea (the Democratic People''s Republic of)', 'Korea (the Democratic People''s Republic of)', 'Korea (the Democratic People''s Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KR', 'KOR', 410, 'Korea (the Republic of)', 'Korea (the Republic of)', 'Korea (the Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KW', 'KWT', 414, 'Kuwait', 'Kuwait', 'Kuwait');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KG', 'KGZ', 417, 'Kyrgyzstan', 'Kyrgyzstan', 'Kyrgyzstan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LA', 'LAO', 418, 'Lao People''s Democratic Republic (the)', 'Lao People''s Democratic Republic (the)', 'Lao People''s Democratic Republic (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LV', 'LVA', 428, 'Latvia', 'Latvia', 'Latvia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LB', 'LBN', 422, 'Lebanon', 'Lebanon', 'Lebanon');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LS', 'LSO', 426, 'Lesotho', 'Lesotho', 'Lesotho');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LR', 'LBR', 430, 'Liberia', 'Liberia', 'Liberia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LY', 'LBY', 434, 'Libya', 'Libya', 'Libya');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LI', 'LIE', 438, 'Liechtenstein', 'Liechtenstein', 'Liechtenstein');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LT', 'LTU', 440, 'Lithuania', 'Lithuania', 'Lithuania');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LU', 'LUX', 442, 'Luxembourg', 'Luxembourg', 'Luxembourg');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MO', 'MAC', 446, 'Macao', 'Macao', 'Macao');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MK', 'MKD', 807, 'Macedonia (the former Yugoslav Republic of)', 'Macedonia (the former Yugoslav Republic of)', 'Macedonia (the former Yugoslav Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MG', 'MDG', 450, 'Madagascar', 'Madagascar', 'Madagascar');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MW', 'MWI', 454, 'Malawi', 'Malawi', 'Malawi');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MY', 'MYS', 458, 'Malaysia', 'Malaysia', 'Malaysia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MV', 'MDV', 462, 'Maldives', 'Maldives', 'Maldives');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ML', 'MLI', 466, 'Mali', 'Mali', 'Mali');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MT', 'MLT', 470, 'Malta', 'Malta', 'Malta');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MH', 'MHL', 584, 'Marshall Islands (the)', 'Marshall Islands (the)', 'Marshall Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MQ', 'MTQ', 474, 'Martinique', 'Martinique', 'Martinique');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MR', 'MRT', 478, 'Mauritania', 'Mauritania', 'Mauritania');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MU', 'MUS', 480, 'Mauritius', 'Mauritius', 'Mauritius');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('YT', 'MYT', 175, 'Mayotte', 'Mayotte', 'Mayotte');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MX', 'MEX', 484, 'Mexico', 'Mexico', 'Mexico');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('FM', 'FSM', 583, 'Micronesia (Federated States of)', 'Micronesia (Federated States of)', 'Micronesia (Federated States of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MD', 'MDA', 498, 'Moldova (the Republic of)', 'Moldova (the Republic of)', 'Moldova (the Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MC', 'MCO', 492, 'Monaco', 'Monaco', 'Monaco');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MN', 'MNG', 496, 'Mongolia', 'Mongolia', 'Mongolia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ME', 'MNE', 499, 'Montenegro', 'Montenegro', 'Montenegro');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MS', 'MSR', 500, 'Montserrat', 'Montserrat', 'Montserrat');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MA', 'MAR', 504, 'Morocco', 'Morocco', 'Morocco');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MZ', 'MOZ', 508, 'Mozambique', 'Mozambique', 'Mozambique');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MM', 'MMR', 104, 'Myanmar', 'Myanmar', 'Myanmar');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NA', 'NAM', 516, 'Namibia', 'Namibia', 'Namibia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NR', 'NRU', 520, 'Nauru', 'Nauru', 'Nauru');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NP', 'NPL', 524, 'Nepal', 'Nepal', 'Nepal');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NL', 'NLD', 528, 'Netherlands (the)', 'Netherlands (the)', 'Netherlands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NC', 'NCL', 540, 'New Caledonia', 'New Caledonia', 'New Caledonia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NZ', 'NZL', 554, 'New Zealand', 'New Zealand', 'New Zealand');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NI', 'NIC', 558, 'Nicaragua', 'Nicaragua', 'Nicaragua');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NE', 'NER', 562, 'Niger (the)', 'Niger (the)', 'Niger (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NG', 'NGA', 566, 'Nigeria', 'Nigeria', 'Nigeria');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NU', 'NIU', 570, 'Niue', 'Niue', 'Niue');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NF', 'NFK', 574, 'Norfolk Island', 'Norfolk Island', 'Norfolk Island');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MP', 'MNP', 580, 'Northern Mariana Islands (the)', 'Northern Mariana Islands (the)', 'Northern Mariana Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('NO', 'NOR', 578, 'Norway', 'Norway', 'Norway');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('OM', 'OMN', 512, 'Oman', 'Oman', 'Oman');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PK', 'PAK', 586, 'Pakistan', 'Pakistan', 'Pakistan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PW', 'PLW', 585, 'Palau', 'Palau', 'Palau');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PS', 'PSE', 275, 'Palestine, State of', 'Palestine, State of', 'Palestine, State of');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PA', 'PAN', 591, 'Panama', 'Panama', 'Panama');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PG', 'PNG', 598, 'Papua New Guinea', 'Papua New Guinea', 'Papua New Guinea');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PY', 'PRY', 600, 'Paraguay', 'Paraguay', 'Paraguay');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PE', 'PER', 604, 'Peru', 'Peru', 'Peru');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PH', 'PHL', 608, 'Philippines (the)', 'Philippines (the)', 'Philippines (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PN', 'PCN', 612, 'Pitcairn', 'Pitcairn', 'Pitcairn');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PL', 'POL', 616, 'Poland', 'Poland', 'Poland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PT', 'PRT', 620, 'Portugal', 'Portugal', 'Portugal');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PR', 'PRI', 630, 'Puerto Rico', 'Puerto Rico', 'Puerto Rico');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('QA', 'QAT', 634, 'Qatar', 'Qatar', 'Qatar');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('RE', 'REU', 638, 'Réunion', 'Réunion', 'Réunion');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('RO', 'ROU', 642, 'Romania', 'Romania', 'Romania');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('RU', 'RUS', 643, 'Russian Federation (the)', 'Russian Federation (the)', 'Russian Federation (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('RW', 'RWA', 646, 'Rwanda', 'Rwanda', 'Rwanda');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('BL', 'BLM', 652, 'Saint Barthélemy', 'Saint Barthélemy', 'Saint Barthélemy');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SH', 'SHN', 654, 'Saint Helena, Ascension and Tristan da Cunha', 'Saint Helena, Ascension and Tristan da Cunha', 'Saint Helena, Ascension and Tristan da Cunha');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LC', 'LCA', 662, 'Saint Lucia', 'Saint Lucia', 'Saint Lucia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('MF', 'MAF', 663, 'Saint Martin (French part)', 'Saint Martin (French part)', 'Saint Martin (French part)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('WS', 'WSM', 882, 'Samoa', 'Samoa', 'Samoa');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SM', 'SMR', 674, 'San Marino', 'San Marino', 'San Marino');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ST', 'STP', 678, 'Sao Tome and Principe', 'Sao Tome and Principe', 'Sao Tome and Principe');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SA', 'SAU', 682, 'Saudi Arabia', 'Saudi Arabia', 'Saudi Arabia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SN', 'SEN', 686, 'Senegal', 'Senegal', 'Senegal');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('RS', 'SRB', 688, 'Serbia', 'Serbia', 'Serbia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SC', 'SYC', 690, 'Seychelles', 'Seychelles', 'Seychelles');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SL', 'SLE', 694, 'Sierra Leone', 'Sierra Leone', 'Sierra Leone');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SG', 'SGP', 702, 'Singapore', 'Singapore', 'Singapore');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SX', 'SXM', 534, 'Sint Maarten (Dutch part)', 'Sint Maarten (Dutch part)', 'Sint Maarten (Dutch part)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SK', 'SVK', 703, 'Slovakia', 'Slovakia', 'Slovakia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SI', 'SVN', 705, 'Slovenia', 'Slovenia', 'Slovenia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SB', 'SLB', 90, 'Solomon Islands', 'Solomon Islands', 'Solomon Islands');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SO', 'SOM', 706, 'Somalia', 'Somalia', 'Somalia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ZA', 'ZAF', 710, 'South Africa', 'South Africa', 'South Africa');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SS', 'SSD', 728, 'South Sudan', 'South Sudan', 'South Sudan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ES', 'ESP', 724, 'Spain', 'Spain', 'Spain');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('LK', 'LKA', 144, 'Sri Lanka', 'Sri Lanka', 'Sri Lanka');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SD', 'SDN', 729, 'Sudan (the)', 'Sudan (the)', 'Sudan (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SR', 'SUR', 740, 'Suriname', 'Suriname', 'Suriname');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SJ', 'SJM', 744, 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SZ', 'SWZ', 748, 'Swaziland', 'Swaziland', 'Swaziland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SE', 'SWE', 752, 'Sweden', 'Sweden', 'Sweden');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('CH', 'CHE', 756, 'Switzerland', 'Switzerland', 'Switzerland');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('SY', 'SYR', 760, 'Syrian Arab Republic', 'Syrian Arab Republic', 'Syrian Arab Republic');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TW', 'TWN', 158, 'Taiwan (Province of China)', 'Taiwan (Province of China)', 'Taiwan (Province of China)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TJ', 'TJK', 762, 'Tajikistan', 'Tajikistan', 'Tajikistan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TZ', 'TZA', 834, 'Tanzania, United Republic of', 'Tanzania, United Republic of', 'Tanzania, United Republic of');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TH', 'THA', 764, 'Thailand', 'Thailand', 'Thailand');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TL', 'TLS', 626, 'Timor-Leste', 'Timor-Leste', 'Timor-Leste');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TG', 'TGO', 768, 'Togo', 'Togo', 'Togo');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TK', 'TKL', 772, 'Tokelau', 'Tokelau', 'Tokelau');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TO', 'TON', 776, 'Tonga', 'Tonga', 'Tonga');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TT', 'TTO', 780, 'Trinidad and Tobago', 'Trinidad and Tobago', 'Trinidad and Tobago');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TN', 'TUN', 788, 'Tunisia', 'Tunisia', 'Tunisia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TR', 'TUR', 792, 'Turkey', 'Turkey', 'Turkey');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TM', 'TKM', 795, 'Turkmenistan', 'Turkmenistan', 'Turkmenistan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TC', 'TCA', 796, 'Turks and Caicos Islands (the)', 'Turks and Caicos Islands (the)', 'Turks and Caicos Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('TV', 'TUV', 798, 'Tuvalu', 'Tuvalu', 'Tuvalu');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('UG', 'UGA', 800, 'Uganda', 'Uganda', 'Uganda');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('UA', 'UKR', 804, 'Ukraine', 'Ukraine', 'Ukraine');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('AE', 'ARE', 784, 'United Arab Emirates (the)', 'United Arab Emirates (the)', 'United Arab Emirates (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('GB', 'GBR', 826, 'United Kingdom of Great Britain and Northern Ireland (the)', 'United Kingdom of Great Britain and Northern Ireland (the)', 'United Kingdom of Great Britain and Northern Ireland (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('UM', 'UMI', 581, 'United States Minor Outlying Islands (the)', 'United States Minor Outlying Islands (the)', 'United States Minor Outlying Islands (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('US', 'USA', 840, 'United States of America (the)', 'United States of America (the)', 'United States of America (the)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('UY', 'URY', 858, 'Uruguay', 'Uruguay', 'Uruguay');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('UZ', 'UZB', 860, 'Uzbekistan', 'Uzbekistan', 'Uzbekistan');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VU', 'VUT', 548, 'Vanuatu', 'Vanuatu', 'Vanuatu');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VE', 'VEN', 862, 'Venezuela (Bolivarian Republic of)', 'Venezuela (Bolivarian Republic of)', 'Venezuela (Bolivarian Republic of)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VN', 'VNM', 704, 'Viet Nam', 'Viet Nam', 'Viet Nam');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VG', 'VGB', 92, 'Virgin Islands (British)', 'Virgin Islands (British)', 'Virgin Islands (British)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('VI', 'VIR', 850, 'Virgin Islands (U.S.)', 'Virgin Islands (U.S.)', 'Virgin Islands (U.S.)');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('WF', 'WLF', 876, 'Wallis and Futuna', 'Wallis and Futuna', 'Wallis and Futuna');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('EH', 'ESH', 732, 'Western Sahara*', 'Western Sahara*', 'Western Sahara*');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('YE', 'YEM', 887, 'Yemen', 'Yemen', 'Yemen');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ZM', 'ZMB', 894, 'Zambia', 'Zambia', 'Zambia');
    INSERT INTO country(id, a3, num, full_name, short_name, display_name) VALUES ('ZW', 'ZWE', 716, 'Zimbabwe', 'Zimbabwe', 'Zimbabwe');
